package com.huabo.contract.oracle.mapper;

import com.huabo.contract.oracle.entity.TblAttachment;
import com.huabo.contract.oracle.entity.TblContractSpnode;
import com.huabo.contract.oracle.entity.TblCyhwProjectbudget;
import com.huabo.contract.oracle.entity.TblFundPool;
import com.huabo.contract.oracle.entity.TblInvestmentProject;

import net.sf.json.JSONObject;

import java.math.BigDecimal;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.UpdateProvider;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hbfk.entity.TblStaffUtil;
import com.hbfk.util.PageInfo;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author huabo
 * @since 2021-10-23
 */
public interface TblInvestmentProjectMapper extends BaseMapper<TblInvestmentProject> {

	 
	@Insert("INSERT INTO TBL_INVESTMENT_PROJECT(PROJECTID,PROJECTNO,PROJECTNAME) VALUES(#{id},#{no},#{name})")
	void insertTblInvestmentProject(@Param("id")String id, @Param("no")String no,@Param("name")String name);
 
	@Update("UPDATE TBL_INVESTMENT_PROJECT SET PROJECTNO = #{no} ,PROJECTNAME = #{name} WHERE PROJECTID = #{id}")
	void updateTblInvestmentProject(@Param("id")String id, @Param("no")String no,@Param("name")String name) throws Exception;
  
	@Select("SELECT COUNT(*) FROM TBL_INVESTMENT_PROJECT WHERE PROJECTID=#{id}")
	Integer selectTblInvestmentProject(@Param("id")String id) throws Exception;

}
